How to: Insert a cell or cells on a worksheet.
Solution:
Click where the cell is to be inserted, select 'Cells...' from the 'Insert' menu, and select 'Shift Cells Right' or 'Shift Cells Down'.
1) Click where the cell will be inserted.
2) Select the 'Insert' menu and select 'Cells...'. (The Insert dialog box appears.)
NOTE: Alternatively, select the cell, click on the right mouse button, and select 'Insert...' from the shortcut menu.
3) Do one of the following:
a) Select the 'Shift Cells Right' radio button to insert the cell and move the original cell to the right.
b) Select the 'Shift Cells Down' radio button to insert the cell and move the original cell down.
4) Click 'OK'.
NOTE: To insert multiple cells, highlight the desired number of cells in the worksheet and follow steps 2) through 4) above.